Intro Paragraph
Safety issues have always been in the spotlight, in the United States as strict gun regulations do not exist. And with the non-stop UW Alert messages reporting crimes, such as robberies and gun fires, safety has become one of the UW students’ major concerns nowadays. Therefore, as a team, we decided to tie this project to our daily lives and analyze the pattern of crimes around our community.
We will be using 3 data sets (SPD Crime Data, King County Sheriff’s Office - Incident Dataset, 911 Seattle Call Data). These datasets contain data such as offense start time, latitude & longitude, offense type, call-in resolution, etc., that help us answer these following questions:
- What areas have the highest density of crime?
- What types of crime? And in what areas?
- What is the time of year or day for the offense, length of offense, report date?
- What is the relationship between call-ins and arrests (i.e. resolution of call-ins)?
Data Description
- SPD Crime Data: This dataset provides crime data using the standardized crime classifications and is updated every twenty four hours.
- King County Sheriff’s Office - Incident Dataset: This dataset contains instances of crime reported by King Country Sherrif office and another policing agency, e.g. SPD.
- 911 Seattle Call Data: 911 call data is from the Data Analytics Platform (DAP) and is logged with the Seattle Police Department (SPD) Communications Center. It contains calls of police officers and observations of the field from within the community and is updated(upload) daily before a full refresh twice a year. Although the dataset is quite huge with 4.34 Million rows of data, we acknowledge our constraint as this dataset only includes records with police responses to the 911 call.
Summary Paragraph
Table